COURSE INTRODUCTION AND APPLICATION INFORMATION

Course Name
Database Systems II
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
MBP 108
Spring
2
2
3
5
Prerequisites
None
Course Language
Turkish
Course Type
Required
Course Level
Short Cycle
Mode of Delivery -
Teaching Methods and Techniques of the Course
Course Coordinator -
Course Lecturer(s)
Assistant(s) -
Course Objectives The aim of this course is to provide knowledge on basic principles, concepts and application areas of database systems
Learning Outcomes The students who succeeded in this course;
  • Will be able to have knowledge on the basic properties and usage of database concept
  • Will be able to perform database design and programming
  • Will be able to have knowledge on relational database concept and its management
  • Will be able to be able to manage all the data stored in database server, efficiently
  • Will be able to have detailed knowledge on security requirements of database systems
Course Description Design, programming and management of database systems
Related Sustainable Development Goals

 



Course Category

 Core Courses
X
Major Area Courses
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Required Materials
1 Introduction
2 Review of Database I Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017). Part 1-3
3 Review of Database I Kaya, Y., Tekin, R.,"Veri tabanı ve uygulamaları", Papatya yayınları (2017). Part 1-3
4 Constraints Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1
5 Views Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 2
6 Transactions Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 3
7 Relational Database Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 4
8 Midterm
9 Functions Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 5
10 Triggers Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 6
11 Stored procedures Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 7
12 Programming Lab Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7
13 Programming Lab 2 Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7
14 Programming Lab 3 Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7
15 Review of the semester Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). Part 1-7
16 Final
Course Notes/Textbooks

Course slides, output and SQL language source codes in digital format

Köseoğlu, K.,"Veritabanı Mantığı",Papatya Yayıncılık (2005). ISBN: 9786052359624
Suggested Readings/Materials Veri tabanı ve uygulamaları Yılmaz Kaya, Ramazan Tekin. Papatya yayınları. Veritabanı Mantığı, Kerem Köseoğlu, Papatya Yayıncılık

 

EVALUATION SYSTEM

Semester Activities Number Weigthing
Participation
1
10
Laboratory / Application
Field Work
Quizzes / Studio Critiques
Portfolio
Homework / Assignments
1
30
Presentation / Jury
Project
Seminar / Workshop
Oral Exam
Midterm
1
30
Final Exam
1
30
Total

Weighting of Semester Activities on the Final Grade
4
60
Weighting of End-of-Semester Activities on the Final Grade
1
40
Total

ECTS / WORKLOAD TABLE

Semester Activities Number Duration (Hours) Workload
Course Hours
(Including exam week: 16 x total hours)
16
2
32
Laboratory / Application Hours
(Including exam week: 16 x total hours)
16
2
Study Hours Out of Class
16
3
48
Field Work
Quizzes / Studio Critiques
Portfolio
Homework / Assignments
1
10
Presentation / Jury
Project
-
Seminar / Workshop
Oral Exam
Midterms
1
6
Final Exams
1
8
    Total
136

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
 Program Competencies/Outcomes
* Contribution Level
1
2
3
4
5
1

To be able to have basic computer hardware and software knowledge.

 X
2

To be able to develop the necessary applications by using internet and network technologies.

 X
3

To follow developments in the field to adapt to changing conditions.

 X
4

To be able to conduct experiments in the field and analyze the results.

 X
5

To be able to use basic programming languages related to the field.

 X
6

To be able to design and install a computer system that includes software, hardware, or both, meeting the basic needs of the field.

 X
7

To be able to interpret and follow current developments in the field of computer programming.
8

To be able to carry professional and ethical responsibility and have awareness of professional ethics in their practices.

 X
9

To have basic theoretical and practical knowledge about mathematics, computing and computer science.
10

To be able to follow the information in the field and communicate with colleagues by using English at the general level of European Language Portfolio A2.
11

To be able to direct his/her education to a further level of education

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest